<%-- 
    Document   : contentlist
    Created on : Apr 24, 2012, 1:02:12 PM
    Author     : Winzelric
--%>

<%@page import="java.sql.DriverManager"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<%@include file="header.jsp" %>


<script type="text/javascript" src="contentlist.js"></script>
<link href="contentlist.css" rel="stylesheet" type="text/css" media="screen" />

<div class='list' id="tagsearch">
  <%
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    String url = "jdbc:mysql://127.0.0.1:3306/progin_171_13509024?user=progin&password=progin";
    Connection conn = DriverManager.getConnection(url);
    Statement statement = conn.createStatement();
    ResultSet result = statement.executeQuery("SELECT * FROM tbl_tag");
    while (result.next()) {
      out.println("<label for='email'>"+result.getString("name") +"</label></br>");
    }
  %>
  <input type='text' class='inputtext' name='tags' id='tags' tabindex='1'>
  <table cellspacing='0'>
    <tr>
      <td>
        <input  type='button' value='Tag Search' onclick='updateContentList(1)'>
      </td>
      <td>
        <select id='selectsort'>
          <option value='1'>Unsorted</option>
          <option value='2'>Most Popular</option>
          <option value='3'>Most Commented</option>
          <option value='4'>Newest</option>
        </select>
      </td>
    </tr>
  </table>

</div>
<div id="content"></div>
<div id="page"></div>
</body>
</html>